package com.kdd.campus.sh.dao;
import com.kdd.campus.sh.po.ShComment;
import org.apache.ibatis.annotations.Select;
import tk.mybatis.mapper.common.Mapper;

import java.util.List;

/****
 * @Author:shenkunlin
 * @Description:ShComment的Dao
 * @Date 2019/6/14 0:12
 *****/
public interface ShCommentMapper extends Mapper<ShComment> {
    @Select("select * from sh_comment where productId=#{productId} AND `status`=1 ORDER BY create_time DESC;")
    List<ShComment> findByProductId(Long productId);
}
